package metalink.admin;
import com.opensymphony.xwork2.ActionSupport;
import java.util.*;
import java.sql.*;
import vo.*;
import vo.mixed.*;
import model.admin.*;
import myutil.*;


public class AddStaff extends ActionSupport{
	String staff_name;
	public String getStaff_name() {
		return staff_name;
	}
	public void setStaff_name(String staff_name) {
		this.staff_name = staff_name;
	}
	public String getDesignation() {
		return designation;
	}
	public void setDesignation(String designation) {
		this.designation = designation;
	}
	public String getJoining_date() {
		return joining_date;
	}
	public void setJoining_date(String joining_date) {
		this.joining_date = joining_date;
	}
	public String getPhone_number() {
		return phone_number;
	}
	public void setPhone_number(String phone_number) {
		this.phone_number = phone_number;
	}
	public String getAddress_line() {
		return address_line;
	}
	public void setAddress_line(String address_line) {
		this.address_line = address_line;
	}
	public String getCity() {
		return city;
	}
	public void setCity(String city) {
		this.city = city;
	}
	public String getState() {
		return state;
	}
	public void setState(String state) {
		this.state = state;
	}
	public String getCountry() {
		return country;
	}
	public void setCountry(String country) {
		this.country = country;
	}
	public String getEmail_id() {
		return email_id;
	}
	public void setEmail_id(String email_id) {
		this.email_id = email_id;
	}
	public int getStaff_type() {
		return staff_type;
	}
	public void setStaff_type(int staff_type) {
		this.staff_type = staff_type;
	}
	public String getRole() {
		return role;
	}
	public void setRole(String role) {
		this.role = role;
	}
	public String getRoll_number() {
		return roll_number;
	}
	public void setRoll_number(String roll_number) {
		this.roll_number = roll_number;
	}
	public int getAcc_no() {
		return acc_no;
	}
	public void setAcc_no(int acc_no) {
		this.acc_no = acc_no;
	}
	public int getStaff_id() {
		return staff_id;
	}
	public void setStaff_id(int staff_id) {
		this.staff_id = staff_id;
	}
	String designation;
	String joining_date;
	String phone_number;
	String address_line;
	String city;
	String state;
	String country;
	String email_id;
	int staff_type;
	String role;
	String roll_number;
	int acc_no;
	int staff_id;
public String execute() throws Exception{
    Connect c=new Connect();
    c.dml("INSERT INTO  `college_db_schema`.`college_staff` (`staff_id`,`staff_name` ,`roll_number` ,`designation` ,`joining_date` ,`phone_number` ,`address_line` ,`city` ,`state` ,`country` ,`email_id` ,`staff_type` ,`role` ,`acc_no`)VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)");
	return address_line;
    


}


}